<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta content="text/html; charset=us-ascii" http-equiv="content-type" />

  <title>Jailer - Scott.sql</title>
</head>

<body>
  <table style="background-color: rgb(51, 102, 255); text-align: left;" border="0"
  cellpadding="2" cellspacing="0">
    <tbody>
      <tr>
        <td style=
        "height: 24px; background-color: rgb(202, 225, 235); vertical-align: top;">
        <big><span style="font-family: monospace;"><span style=
        "font-weight: bold;"><span style=
        "font-family: monospace;">scott.sql</span></span></span> </big><br /></td>
      </tr>
    </tbody>
  </table>

  <table style="width: 100%; text-align: left;" border="0" cellpadding="0" cellspacing=
  "0">
    <tbody>
      <tr>
        <td colspan="2" rowspan="1" style=
        "background-color: rgb(202, 225, 235); vertical-align: top;"><span style=
        "font-family: monospace;">-- generated by Jailer<br />
        --<br />
        -- extraction model:&nbsp; EMPLOYEE where NAME='SCOTT'
        (extractionmodel/scott.csv)<br />
        -- database URL:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jdbc:db2://localhost/wisser<br />
        -- database user:&nbsp;&nbsp;&nbsp;&nbsp; scott</span><span style=
        "font-family: monospace;"><br />
        -- Exported Entities: 43<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        DEPARTMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        3<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        EMPLOYEE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        14<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        PROJECT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        4<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        PROJECT_PARTICIPATION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        14<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        ROLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        3<br />
        --&nbsp;&nbsp;&nbsp;&nbsp;
        SALARYGRADE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        5<br />
        <br />
        <br />
        <br />
        Insert into SALARYGRADE(GRADE, LOSAL, HISAL) values (4, 2001, 3000), (1, 700,
        1200), (5, 3001, 9999), (2, 1201, 1400), (3, 1401, 2000);<br />
        Insert into ROLE(ROLE_ID, DESCRIPTION) values (100, 'Developer'), (102, 'Project
        manager'), (101, 'Researcher');<br />
        Insert into PROJECT(PROJECTNO, DESCRIPTION, START_DATE, END_DATE) values (1001,
        'Development of Novel Magnetic Suspension System', '2006-01-01', '2007-08-13'),
        (1002, 'Research on thermofluid dynamics in Microdroplets', '2006-08-22',
        '2007-03-20'), (1003, 'Foundation of Quantum Technology', '2007-02-24',
        '2008-07-31'), (1004, 'High capacity optical network', '2008-01-01', null);<br />
        Insert into DEPARTMENT(DEPTNO, NAME, LOCATION) values (20, 'RESEARCH', 'DALLAS'),
        (10, 'ACCOUNTING', 'NEW YORK'), (30, 'SALES', 'CHICAGO');<br />
        Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
        values (7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000.00, null, 10);<br />
        Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
        values (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, null, 20), (7698,
        'BLAKE', 'MANAGER', 7839, '1981-05-01', 2850.00, null, 30), (7782, 'CLARK',
        'MANAGER', 7839, '1981-06-09', 2450.00, null, 10);<br />
        Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
        values (7788, 'SCOTT', 'ANALYST', 7566, '1982-12-09', 3000.00, null, 20), (7902,
        'FORD', 'ANALYST', 7566, '1981-12-03', 3000.00, null, 20), (7900, 'JAMES',
        'CLERK', 7698, '1981-12-03', 950.00, null, 30), (7499, 'ALLEN', 'SALESMAN', 7698,
        '1981-02-20', 1600.00, 300.00, 30), (7521, 'WARD', 'SALESMAN', 7698,
        '1981-02-22', 1250.00, 500.00, 30), (7654, 'MARTIN', 'SALESMAN', 7698,
        '1981-09-28', 1250.00, 1400.00, 30), (7844, 'TURNER', 'SALESMAN', 7698,
        '1981-09-08', 1500.00, 0.00, 30), (7934, 'MILLER', 'CLERK', 7782, '1982-01-23',
        1300.00, null, 10);<br />
        Insert into PROJECT_PARTICIPATION(PROJECTNO, EMPNO, START_DATE, END_DATE,
        ROLE_ID) values (1003, 7566, '2007-02-24', '2008-07-31', 102), (1002, 7782,
        '2006-08-22', '2007-03-20', 101);<br />
        Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO)
        values (7876, 'ADAMS', 'CLERK', 7788, '1983-01-12', 1100.00, null, 20), (7369,
        'SMITH', 'CLERK', 7902, '1980-12-17', 800.00, null, 20);<br />
        Insert into PROJECT_PARTICIPATION(PROJECTNO, EMPNO, START_DATE, END_DATE,
        ROLE_ID) values (1001, 7788, '2006-05-15', '2006-11-01', 100), (1001, 7902,
        '2006-01-01', '2006-12-30', 102), (1002, 7934, '2007-01-01', '2007-03-20', 101),
        (1003, 7900, '2007-02-24', '2007-01-31', 101), (1004, 7499, '2008-01-01', null,
        102), (1004, 7521, '2008-05-01', null, 101), (1004, 7654, '2008-04-15', null,
        101), (1004, 7844, '2008-02-01', null, 101), (1004, 7900, '2008-03-01',
        '2008-04-01', 101), (1004, 7900, '2008-05-20', null, 101);<br />
        Insert into PROJECT_PARTICIPATION(PROJECTNO, EMPNO, START_DATE, END_DATE,
        ROLE_ID) values (1002, 7876, '2006-08-22', '2007-03-20', 102), (1001, 7369,
        '2006-01-01', '2007-08-13', 100);<br />
        <br /></span></td>
      </tr>
    </tbody>
  </table><br />
  <br />
</body>
</html>
